<?php
// #region demo
$link = mysqli_connect('127.0.0.1', 'root', 'root', 'test');

if ($link !== false) {
    echo "Link connected.";
}
// #endregion demo

$result = mysqli_query($link, "SELECT * FROM users WHERE id  = 1");

if ($result instanceof mysqli_result) {
    $row = mysqli_fetch_row($result);
    if (is_array($row)) {
        var_dump($row);
        echo sprintf("account => %s, password => %s", $row['account'], $row['password']);
    }
}
